forum

Home / DeveloperSection / Forums / Write a PL/SQL code to find whether a given string is a palindrome or not.

Ask Question
Revati S Misra

Revati S Misra

Follow
Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Can you answer this question?

Answer

1 Answers

Krishnapriya Rajeev

Krishnapriya Rajeev

05-Apr-2023

The following PL/SQL program checks whether the given string is a palindrome or not:

SET SERVEROUTPUT ON
DECLARE
     -- declare the string to be checked
     str VARCHAR2(10) := 'RACECAR';
     rev VARCHAR(10);
     c VARCHAR2(1);
   
begin
     -- for each character from last to first
     FOR i IN REVERSE 1..Length(str) LOOP
           -- extract each character from string
           c := Substr(str, i, 1);
          
           -- concatenate each character to reverse string
           rev := rev || c;
     END LOOP;
     
     -- check if both string and its reverse are equal
     IF rev = str
     THEN
           dbms_output.put_line(str || ' is a palindrome.');
     ELSE
           dbms_output.put_line(str || ' is not a palindrome.');
     END IF;
END;
/
-- OUTPUT : RACECAR is a palindrome.

We first declare the variables str (the string to be checked), rev (to store the reversed string), and c (to extract each character). Using a FOR loop that iterates from the length of the string to 1, we extract each character from the string and concatenate it to the reversed string. Finally, we check if str and rev are equal. If they are, the string is a palindrome.

Liked By